﻿CREATE TABLE [org].[Portfolio] (
    [PortfolioId]                      INT             NOT NULL,
    [PortfolioCode]                    CHAR (5)        NOT NULL,
    [PortfolioName]                    VARCHAR (50)    NOT NULL,
    [PortfolioDescription]             NVARCHAR (1000) NULL,
    [PortfolioFlashPnlMinThresholdGBP] DECIMAL (18, 2) NULL,
    [PortfolioFlashPnLMaxThresholdGBP] DECIMAL (18, 2) NULL,
    [PortfolioFlashManualUpload]       BIT             NOT NULL,
    [PortfolioFlashMurexUpload]        BIT             NOT NULL,
    [PortfolioStartDate]               DATE            NOT NULL,
    [PortfolioEndDate]                 DATE            NULL,
    [IsLatest]                         BIT             NOT NULL,
    [IsActive]                         BIT             NOT NULL,
    [IsInternal]                       BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([PortfolioId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

